Overview: Concatenate

Concatenation is the joining of two items to form a new item, which is a combination of both the part items. Thus the concatenation of two strings ab and cd is the string abcd, formed by joining ab and cd.

Use this operation to concatenate different field values into a new string value, within a newly created field. The resulting modified dataset will get an extra field containing the concatenated values. Other existing fields remain unaffected.

Properties

Category:	Add
Performance risk:	Low performance risk
Knowledge required:	None

Effect on datasets

How many datasets are required to perform this operation?	One
Does it create a new dataset?	No
Can you reconfigure this operation?	Yes
Can you apply this operation to a locked dataset?	No
Does it modify the current dataset in any way?	Yes

Requirements

This operation needs a dataset that contains at least one field.

Results

A modified dataset with a newly created field containing the concatenated values.
The original fields will be unaffected by this operation.
One proviso is that there needs to be enough space inside the dataset for the new field that contains the concatenated values to be added.